
create external table jms_ods.sqs_project_customer_config (
  `id` bigint(20)  comment '主键id',
  `first_type_name` string  comment '一级项目名称',
  `first_type_code` string comment '一级项目编码',
  `second_type_name` string comment '二级项目名称',
  `customer_code` string comment '客户编码',
  `create_time` TIMESTAMP comment '创建时间',
  `update_time` TIMESTAMP comment '更新时间'

) comment'项目与客户信息关联表'
 PARTITIONED BY (
   `dt` string COMMENT '时间分区(yyyy-MM-dd-HH)')
stored as parquet
 LOCATION
   '/dw/hive/jms_ods.db/external/sqs_project_customer_config'
     TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );